﻿IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].tb_project_user') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_project_user
(
    Id INT IDENTITY(1,1) NOT NULL,
	ProjectCode varchar(3) not null,
	username varchar(20) not null,
	CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_project_user_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO